<?php 

include("header.php3");

//Funredes intro
$fontcolor6 = "black";
$bgcolor6 = "navy";

//anuncios y especiales
$fontcolor1 = "white";
$bgcolor5 = "navy";
$bordercolor1 = $bg_bottomline;
$bgcolor_top = $bg_bottomline;

//Funredes Slogan
$fontcolor7 = "white";
$bgcolor7 = "#68d038";

	$label_menu_col1_row1 = $label_menu_a1;
	$label_menu_col1_row2 = $label_menu_a2;
	$label_menu_col1_row3 = $label_menu_a3;
	$label_menu_col1_row4 = $label_menu_a4;
	$label_menu_col1_row5 = $label_menu_a5;
	$label_menu_col1_row6 = $label_menu_a6;
	$label_menu_col2_row1 = $label_menu_b1;
	$label_menu_col2_row2 = $label_menu_b2;
	$label_menu_col2_row3 = $label_menu_b3;
	$label_menu_col2_row4 = $label_menu_b4;
	$label_menu_col2_row5 = $label_menu_b5;
	$label_menu_col2_row6 = $label_menu_b6;
	
	$label_menu_col1_row1_url = "editoriales.php3";
	$label_menu_col1_row2_url = "nuevo.php3";
	$label_menu_col1_row3_url = "../presentation";
	$label_menu_col1_row4_url = "servicios/index.php3";
	$label_menu_col1_row5_url = "institucion/faq.php3";
	$label_menu_col1_row6_url = "institucion/membresia.php3";
	$label_menu_col2_row1_url = "institucion/index.php3";
	$label_menu_col2_row2_url = "brochure.php3";
	$label_menu_col2_row3_url = "funredeson.php3";
	$label_menu_col2_row4_url = "buscarsql.php3";
	$label_menu_col2_row5_url = "infositio/index.php3";
	$label_menu_col2_row6_url = "sitios/sitios.php3";

if ($lang == "es") {

	$label_menu_col1_row1_desc = "Vea los asuntos actuales m&aacute;s importantes en el mundo de las Nuevas Tecnolog&iacute;as de la Informaci&oacute;n y de Comunicaci&oacute;n, seg&uacute;n Funredes.";
	$label_menu_col1_row2_desc = "Con&eacute;ctese a informaci&oacute;n sobre los nuevos proyectos, investigaciones, empleados, servicios y logros de FUNREDES.";
	$label_menu_col1_row3_desc = "¿Sabias que puedes consultar las presentaciones de Funredes en diversas reuniones?";
	$label_menu_col1_row4_desc = "Dise&ntilde;o de web, Cursos de Internet, Asesorias de redes, Alojamiento de Sitios, etc.";
	$label_menu_col1_row5_desc = "Preguntas frecuentes sobre nuestra instituci&oacute;n y nuestros trabajos.";
	$label_menu_col1_row6_desc = "Redes de las cuales FUNREDES es Miembro.";
	$label_menu_col2_row4_desc = "Buscar informaci&oacute;n o un documento espec&iacute;fico en el SIF por palabra clave, o por criterios m&aacute;s avanzados.";
	$label_menu_col2_row2_desc = "El Folleto de Funredes. Consulte una lista completa de nuestras investigaciones y trabajos desde el inicio en 1993.";
	$label_menu_col2_row3_desc = "Un &iacute;ndice de los trabajos de Funredes por tema de relevancia.";
	$label_menu_col2_row1_desc = "Info de contacto, Convenios, Trabajar para FUNREDES, Folleto, Publicidades, Recursos Humanos...";
	$label_menu_col2_row5_desc = "Estad&iacute;sticas:  sepa de d&oacute;nde provienen las conexionesa este servidor.<br>Cr&eacute;ditos, Info del servidor, Concurso de dise&ntilde;o.";	
	$label_menu_col2_row6_desc = "Sitios @ funredes.org:  Listado de todo los sitios desarrollados y/o alojados por Funredes";	


	$label_intro = "es un Organismo No Gubernamental Internacional, dedicado a la difusi&oacute;n de las Nuevas Tecnolog&iacute;as de la Informaci&oacute;n y de la Comunicaci&oacute;n (NTIC) en los pa&iacute;ses en desarrollo, en particular en Am&eacute;rica Latina y el Caribe. Esto en colaboraci&oacute;n con los Organismos Internacionales, ONG, los Estados, las Administraciones y las Instituciones p&uacute;blicas o privadas interesadas, con el objetivo de contribuir al desarrollo e integraci&oacute;n regional.";
	$label_infodisponible = "INFORMACI&Oacute;N DISPONIBLE EN NUESTRO WEB";
	$label_especiales = "ESPECIALES";
	$label_slogan = "Desde el inicio de los a&ntilde;os 90, la posici&oacute;n de FUNREDES acerca de la Internet para el desarrollo no va tan dirigida a los conectores y los sistemas de conexi&oacute;n, la b&uacute;squeda de informaci&oacute;n en el extranjero o la convergencia hacia un idioma, una cultura y un mercado &uacute;nicos. Ser&iacute;a m&aacute;s bien dirigida al mejoramiento de las comunidades y de sus miembros, la colaboraci&oacute;n y el trabajo en red, el desarrollo tanto de los valores locales como de la preservaci&oacute;n de los idiomas, de las culturas y de las opiniones en sus propias identidades. La tecnolog&iacute;a para la comunicaci&oacute;n, y no lo contrario...";

	$lenguaid = 1;

} else if ($lang == "fr") {
	
	$lenguaid = 2;

	$label_menu_col1_row1_desc = "Voir les sujets les plus importants actuellement dans le monde des Nouvelles Technologies d'Information et de Communication selon Funredes.";
	$label_menu_col1_row2_desc = "Connectez-vous &agrave; des informations &agrave; propos des nouveaux projets, des recherches, des employ&eacute;s, des services et des r&eacute;ussites de FUNREDES.";
	$label_menu_col1_row3_desc = "Saviez-vous que vous pouvez consulter les présentations faites par Funredes dans diverses réunions?";
	$label_menu_col1_row4_desc = "Infographie, Cours Internet, Administration de r&eacute;seaux, H&eacute;bergement de Sites, etc.";
	$label_menu_col1_row5_desc = "Foire aux questions au sujet de notre institution.";
	$label_menu_col1_row6_desc = "R&eacute;saux dont FUNREDES est Membre.";
	$label_menu_col2_row4_desc = "Rechercher de l'information ou un document sp&eacute;cifique dans le SIF par mot clef, ou par des crit&egrave;res plus avanc&eacute;s.";
	$label_menu_col2_row2_desc = "La Brochure de Funredes.  Voir une liste de nos travaux depuis le d&eacute;but, en 1993.";
	$label_menu_col2_row3_desc = "Un indexe des travaux de Funredes par sujet.";
	$label_menu_col2_row1_desc = "Information de contact, Conventions, Travailler pour FUNREDES, Brochure, Publicit&eacute;s, Ressources Humaines...";
	$label_menu_col2_row5_desc = "Statistiques : savoir d'o&ugrave; on se connecte &agrave; ce site.<br>Cr&eacute;dits, info sur le serveur, concours d'infographie.";
	$label_menu_col2_row6_desc = "Sites Web @ funredes.org:  Liste des sites web d&eacute;velopp&eacute;s et/ou h&eacute;berg&eacute;s par Funredes";	


	$label_intro = "est une Organisation Non Gouvernementale Internationale, qui se consacre &agrave; la diffusion des Nouvelles Technologies de l'Information et de la Communication (NTIC) dans les pays en voie de d&eacute;veloppement, notamment en Am&eacute;rique Latine et dans les Cara&iuml;bes. Son but : contribuer au d&eacute;veloppement et &agrave; l'int&eacute;gration r&eacute;gionale en collaboration avec les Organisations Internationales, les ONG, les &Eacute;tats, les Administrations et les Institutions publiques ou priv&eacute;es  int&eacute;ress&eacute;es.";

	$label_infodisponible = "INFORMATION DISPONIBLE SUR NOTRE WEB";
	$label_especiales = "EN BREF";
	$label_slogan = "Depuis le d&eacute;but des ann&eacute;es 90, la position de FUNREDES en ce qui concerne l'Internet pour le d&eacute;veloppement n'est pas tourn&eacute;e vers la connectique, la recherche d'informations &agrave; l'&eacute;tranger ou la convergence vers une langue, une culture et un march&eacute; uniques. Mais elle serait plut&ocirc;t tourn&eacute;e vers le renforcement des capacit&eacute;s communautaires et citoyennes, la collaboration et le travail en r&eacute;seau, le d&eacute;veloppement des valeurs locales ainsi que la pr&eacute;servation des langues, des cultures et des opinions dans leurs identit&eacute;s propres. La technologie au service de la communication et non pas l'inverse...";

} else if ($lang == "en") {

	$lenguaid = 3;
	
	$label_menu_col1_row1_desc = "See the latest and most important issues related to New Information and Communication Technology, according to Funredes.";
	$label_menu_col1_row2_desc = "Connect to information about our latest projects, publications, services and achievements.";
	$label_menu_col1_row3_desc = "Did you know you could consult all Funredes's presentation in various meetings?";
	$label_menu_col1_row4_desc = "Web Design, Internet Courses, Network Consulting, Web Hosting and more.";
	$label_menu_col1_row5_desc = "Frecuently Asked Questions about our institution.";
	$label_menu_col1_row6_desc = "Networks of which FUNREDES is member.";
	$label_menu_col2_row4_desc = "Search for general information or a specific document in the SIF by keyword, or by more advanced search criteria.";
	$label_menu_col2_row2_desc = "Our Brochure of what we've done and a link to every publication, project, list, conference attended, etc.  See what we have accomplished since our beginning in 1993.";
	$label_menu_col2_row3_desc = "An index of our work by topic.";
	$label_menu_col2_row1_desc = "Contact Information, Job Opportunities for FUNREDES, Brochure, Publicity, Human Resources.";
	$label_menu_col2_row5_desc = "Web Statistics:  find out who connects to our server.<br>Credits, Info about the server hardware and software, Web Design Contest.";
	$label_menu_col2_row6_desc = "Websites @ funredes.org:  List of the websites designed or/and hosted by Funredes";	

	$label_intro = "is a Non-Governmental Organization, dedicated to the dissemination of New Information and Communication Technologies (NICT) in developing countries, especially in Latin America and the Caribbean. The in collaboration with Internation Organizations, NGO's, the States, Administrations, and public or private institutions, with the objective of contributing to regional development and integration.";
	$label_infodisponible = "INFORMATION AVAILABLE ON OUR SITE";
	$label_especiales = "SPECIALS";
	$label_slogan = "Since the early 90's FUNREDES' position is that \"Internet for Development\" is NOT about plugging and playing, chatting and surfing, getting info abroad, converging to one language, one culture and one market.  It's more about empowering persons and communities, collaborating and social networking, producing local content, facilitating diversity of languages, cultures and opinions. Communication above technology...";

}



$conn = pg_pconnect("dbname=sif user=mike");
$gethot = pg_exec($conn, "SELECT docid, titulo_$lang, descripcion_$lang, fechadecreacion, tipo FROM principal WHERE especial='si' ORDER BY fechadecreacion DESC");
$row = 0;
$rowcount = pg_numrows($gethot);
include("../incluir/filepathandname.inc");
?>


<font size=-1 face="verdana, arial, helvetica">

<table border=0 cellpadding=0 cellspacing=0 align=center width=100%>

<tr>
<td width=175 align=left valign=top>

	<table border="0" cellpadding="3" cellspacing="0" width=100% bgcolor="<?php echo $bordercolor1 ?>">
	<tr><td>
	<table width=100% border=0 cellpadding=3 cellspacing=0>

<?php
// begin anuncios

if ($lang == "es") {
	$label_anuncios = "ANUNCIOS";
	$label_fullstory = "conocer el asunto";
} else if ($lang == "fr") {
	$label_anuncios = "ANNONCES";
	$label_fullstory = "voir l'historique";
} else if ($lang == "en") {
	$label_anuncios = "HEADLINES";
	$label_fullstory = "see the full story";
}

	$queryanuncio = pg_exec($conn, "SELECT docid, titulo_$lang, descripcion_$lang, fechadecreacion FROM principal WHERE tipo=15 AND anuncio_homepage::integer > 0 ORDER BY anuncio_homepage");
	if (pg_numrows($queryanuncio) != 0) {
		?>
		<tr>
		<td align=center bgcolor="<?php echo $bgcolor_top ?>">
		<font face="verdana, arial, helvetica" color=white><b><?php echo $label_anuncios ?></b></font>
		</td>
		</tr>
		<tr>
		<td bgcolor="<?php echo $bgcolor5 ?>"><font face="verdana, arial, helvetica">

		<?php
		$i = 0;
		while ($i < pg_numrows($queryanuncio)) {
			$getanuncio = pg_fetch_row($queryanuncio, $i);
			echo "<font size=-1><a href=\"$getanuncio[2]\">$getanuncio[1]</a><p>\n";
			$i++;
		}
		echo "</td>\n</tr>\n\n";
	}

//end anuncios

?>

	<tr>
	<td bgcolor="<?php echo $bgcolor_top ?>" align=center>
	<font face="verdana, arial, helvetica" color=white><b><?php echo $label_especiales ?></b></center></font>
	</td>
	</tr>
	<td bgcolor="<?php echo $bgcolor5 ?>" valign=top align=left><font face="verdana, arial, helvetica">
            
		<?php

		if ($rowcount > 0) {
		do {
			$listhots = pg_fetch_row($gethot, $row);
			echo "<p><font SIZE=\"2\" COLOR=\"#CC9900\"><b><a href=\"".$filepathandname[$listhots[4]]."/docid/$listhots[0]\">".$listhots[1]."</a><br>";
			echo "</b></font><font size=-2 color=\"$fontcolor1\">$listhots[3]<p>";
			echo "<font size=\"2\" color=\"$fontcolor1\">$listhots[2]<br>";
			$row++;
		} while ($row < $rowcount);
		}
		?>
            </font></font>
	</td>
	</tr>
	</table>
	</td>
	</tr>
	</table>
            
            
</td>
<td valign=top align=right>

	<blockquote><p align=justify><br></br>
          <font face="verdana, arial, helvetica"><font SIZE="-1" COLOR="#cc9900"><b>FUNREDES</b> </font><font SIZE="-1" color="<?php echo $fontcolor6 ?>"><?php echo $label_intro ?></font></font>
	    </p>
      </blockquote>

  <table BORDER="0" width=95%>
          <tr>
            <td VALIGN="top" width="50%"><dl>
              <dt><font face="verdana, arial, helvetica"><img SRC="../images/rombo.gif" BORDER="0" HSPACE="8" WIDTH="11" HEIGHT="11"><strong><font SIZE="2" COLOR="#CC9900"><a href="<?php echo $label_menu_col1_row1_url ?>"><?php echo $label_menu_col1_row1 ?></a></font></strong></dt>
              <dd><font face="verdana, arial, helvetica" SIZE="2"><?php echo $label_menu_col1_row1_desc ?><p>
                </font></dd>
            </dl>
            </td>
            <td VALIGN="top" width="50%"><dl>
              <dt><font face="verdana, arial, helvetica"><img SRC="../images/rombo.gif" BORDER="0" HSPACE="8" WIDTH="11" HEIGHT="11"><font SIZE="2" COLOR="#CC9900"><b><a href="<?php echo $label_menu_col2_row1_url ?>"><?php echo $label_menu_col2_row1 ?></a></b></font></dt>
              </font>
              <dd><font face="verdana, arial, helvetica" SIZE="2"><?php echo $label_menu_col2_row1_desc ?><br></font></dd>
              </dl>
            </td>
          </tr>
          <tr>
            <td VALIGN="top" width="50%"><dl>
              <dt><font face="verdana, arial, helvetica"><img SRC="../images/rombo.gif" BORDER="0" HSPACE="8" WIDTH="11" HEIGHT="11"><b><font SIZE="2" COLOR="#CC9900"><a href="<?php echo $label_menu_col1_row2_url ?>"><?php echo $label_menu_col1_row2 ?></a></font></b></font></dt>
              <font face="verdana, arial, helvetica">
              <dd><font face="verdana, arial, helvetica" SIZE="2"><?php echo $label_menu_col1_row2_desc ?><br></font></font></dd>
            </dl>
            </td>
            <td VALIGN="top" width="50%"><dl>
              <dt><font face="verdana, arial, helvetica"><img SRC="../images/rombo.gif" BORDER="0" HSPACE="8" WIDTH="11" HEIGHT="11"><font SIZE="2" COLOR="#CC9900"><b><a href="<?php echo $label_menu_col2_row2_url ?>"><?php echo $label_menu_col2_row2 ?></a></b></font></font></dt>
              <dd><font face="verdana, arial, helvetica" SIZE="2"><?php echo $label_menu_col2_row2_desc ?><br>
                </font></dd>
            </dl>
            </td>
          </tr>

          <tr>
            <td VALIGN="top" width="50%"><dl>
              <dt><font face="verdana, arial, helvetica"><img SRC="../images/rombo.gif" BORDER="0" HSPACE="8" WIDTH="11" HEIGHT="11"><b><font SIZE="2" COLOR="#CC9900"><a href="<?php echo $label_menu_col1_row3_url ?>"><?php echo $label_menu_col1_row3 ?></a></font></b></dt>
              <dd><font size="2"><?php echo $label_menu_col1_row3_desc ?></font><br>
                </font></dd>
            </dl>
            </td>
	    <td VALIGN="top" width="50%"><dl>
              <dt><font face="verdana, arial, helvetica"><img SRC="../images/rombo.gif" BORDER="0" HSPACE="8" WIDTH="11" HEIGHT="11"><b><font SIZE="2" COLOR="#CC9900"><a href="<?php echo $label_menu_col2_row4_url ?>"><?php echo $label_menu_col2_row4 ?></a></font></b></dt>
              <dd><font face="verdana, arial, helvetica" SIZE="2"><?php echo $label_menu_col2_row4_desc ?><br>
                </font></font></dd>
            </dl>
            </td>
          </tr>

          <tr>
            <td VALIGN="top" width="50%"><dl>
              <dt><font face="verdana, arial, helvetica"><img SRC="../images/rombo.gif" BORDER="0" HSPACE="8" WIDTH="11" HEIGHT="11"><font SIZE="2" COLOR="#CC9900"><b><a href="<?php echo $label_menu_col1_row4_url ?>"><?php echo $label_menu_col1_row4 ?></a></b></font></font></dt>
              <dd><font face="verdana, arial, helvetica" SIZE="2"><?php echo $label_menu_col1_row4_desc ?><br>
                </font></dd>
            </dl>
            </td>
            <td VALIGN="top" width="50%"><dl>
              <dt><font face="verdana, arial, helvetica"><img SRC="../images/rombo.gif" BORDER="0" HSPACE="8" WIDTH="11" HEIGHT="11"><font SIZE="2" COLOR="#CC9900"><b><a href="<?php echo $label_menu_col2_row5_url ?>"><?php echo $label_menu_col2_row5 ?></a></b></font></font></dt>
              <dd><font face="verdana, arial, helvetica" SIZE="2"><?php echo $label_menu_col2_row5_desc ?><br>
                </font></dd>
            </dl>
            </td>
          </tr>
          <tr>
            <td VALIGN="top" width="50%"><dl>
              <dt><font face="verdana, arial, helvetica"><img SRC="../images/rombo.gif" BORDER="0" HSPACE="8" WIDTH="11" HEIGHT="11"><strong><font SIZE="2" COLOR="#CC9900"><a href="<?php echo $label_menu_col1_row5_url ?>"><?php echo $label_menu_col1_row5 ?></a></font></strong></dt>
              <dd><font size="2"><?php echo $label_menu_col1_row5_desc ?><br></font></dd>
            </dl>
            </td>
            <td VALIGN="top" width="50%"><dl>
              <dt><font face="verdana, arial, helvetica"><img SRC="../images/rombo.gif" BORDER="0" HSPACE="8" WIDTH="11" HEIGHT="11"><font SIZE="2" COLOR="#CC9900"><b><a href="<?php echo $label_menu_col2_row6_url ?>"><?php echo $label_menu_col2_row6 ?></a></b></font></font></dt>
              <dd><font face="verdana, arial, helvetica" SIZE="2"><?php echo $label_menu_col2_row6_desc ?><br>
                </font></dd>
            </dl>
            </td>
          </tr>
          <tr>
            <td VALIGN="top" width="50%">
            	<dt><font face="verdana, arial, helvetica"><img SRC="../images/rombo.gif" BORDER="0" HSPACE="8" WIDTH="11" HEIGHT="11"><font SIZE="2" COLOR="#CC9900"><b><a href="<?php echo $label_menu_col1_row6_url ?>"><?php echo $label_menu_col1_row6 ?></a></b></font></font></dt>
              <dd><font face="verdana, arial, helvetica" SIZE="2"><?php echo $label_menu_col1_row6_desc ?>
                </font></dd>
            	</dl>
            </td>
<!--
            <td VALIGN="top" width="50%"><dl>
              <dt><font face="verdana, arial, helvetica"><img SRC="../images/rombo.gif" BORDER="0" HSPACE="8" WIDTH="11" HEIGHT="11"><b><font SIZE="2" COLOR="#CC9900"><a href="<?php echo $label_menu_col2_row3_url ?>"><?php echo $label_menu_col2_row3 ?></a></font></b></dt>
              <dd><font size="2"><?php echo $label_menu_col2_row3_desc ?><br></font></dd>
            </dl>
            </td>
-->
          </tr>
        </table>
        
        

	<font size=-1 face="verdana, arial, helvetica"><p align=right>
	<table width=95% align=right bgcolor="<?php echo $bgcolor7 ?>" cellpadding=3 cellspacing=0>
	<tr><td><font face="<?php echo $font1 ?>" size=-1 color="<?php echo $fontcolor7 ?>">
	<?php echo $label_slogan ?>
	</td></tr></table>
	
       

</td>
</tr>
</table>

</font>



<?php
include("footer.php3");
?>

